UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/VySIdmajbx9eCTeUK+3RwG3rMq1ZsmS89rbeEq4020='
WHERE
key_id = 'b1f47d7c3319e041b80a3dbe1fd5d0e19e6b7f4b1533f7dc0b4042c3e447b655'
AND (
token = '/VySIdmajbx9eCTeUK+3RwG3rMq1ZsmS89rbeEq4020='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)