UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iSBIjcASJbA7T+4IxTFu91mCQY/X+075If7Mn6Z/cnk='
WHERE
key_id = 'f2dcfda5cef333194ec6fb57890079102f8751cda175868645124b83b9ea396d'
AND (
token = 'iSBIjcASJbA7T+4IxTFu91mCQY/X+075If7Mn6Z/cnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)