UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HrS6E9+9s0qSXXoLIwQEVEngYuBUh1QpmhUhaaOOe60='
WHERE
key_id = 'cdebef45c546286913c932298ea3e3d5ff775448c10d5cecf75bc6a49c462a05'
AND (
token = 'HrS6E9+9s0qSXXoLIwQEVEngYuBUh1QpmhUhaaOOe60='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)