UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vGzCnaKKc27oAobTUxnbPEZ2WR7++S39tBY7dZ+UDTw='
WHERE
key_id = '6b337c80ac7b25b420ea27b5e8c847456f9ee173c72cf07d1c072e4477867e71'
AND (
token = 'vGzCnaKKc27oAobTUxnbPEZ2WR7++S39tBY7dZ+UDTw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)