UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4DKYM4hTDQFOc/0gYLZDcZHtBSPQOuI2h1Hb2MKXcHo='
WHERE
key_id = '4789dfe6b125df82449157afd40c2f99ecf320c4ff3dc2cc317955f864c65065'
AND (
token = '4DKYM4hTDQFOc/0gYLZDcZHtBSPQOuI2h1Hb2MKXcHo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)