UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pK21yGMiKBLVoeCb3KkRvPfdDC3MosNPan1e3z5orGc='
WHERE
key_id = 'd97766fcb5f8cad73248f8d05495ccdf24dc11f936dca5f9e1f6a0132e4ffe9e'
AND (
token = 'pK21yGMiKBLVoeCb3KkRvPfdDC3MosNPan1e3z5orGc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)