UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7d0fPB+zPzIooXMVlnB0DL39tonfJo59ExB/miYqDIw='
WHERE
key_id = '0107c8f187a6c278e0966ed4cf63b522969c043244d5182efa4fad9df0993026'
AND (
token = '7d0fPB+zPzIooXMVlnB0DL39tonfJo59ExB/miYqDIw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)