UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rrK7VEBNQKfuM1kT45spqyJMh0e4EZ1hv76LiXRHgzw='
WHERE
key_id = '8c950080ffde925fa10a8ecb64a824a764aeaec3c46b426d0077eb84de5fe3a4'
AND (
token = 'rrK7VEBNQKfuM1kT45spqyJMh0e4EZ1hv76LiXRHgzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)