UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4NYsJcH0N48q64slNAWULTw9ItrWnKlZBArIPX13uds='
WHERE
key_id = '7b9f11666118a77d747de9c347aded1d51b0953c704696df5dd86bbe8bea3efb'
AND (
token = '4NYsJcH0N48q64slNAWULTw9ItrWnKlZBArIPX13uds='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)