UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r7/pZcdzE9wQ/E3SbLM9YTbK1XWkOxeX4oA2pbrRhvU='
WHERE
key_id = '130b82449d81997c3a1253fdf39e95dcf1b290fef82d88bbb997d540f8147056'
AND (
token = 'r7/pZcdzE9wQ/E3SbLM9YTbK1XWkOxeX4oA2pbrRhvU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)