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