UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kV0Pw0sUjmHDKnSq1lX8vYECdPBumf2NFmpLEYENxdQ='
WHERE
key_id = 'ebed9cd7c4f1614f6f8cf4c27b2f4ce35b4cc86b0cda02df3dbc0509ed28ca08'
AND (
token = 'kV0Pw0sUjmHDKnSq1lX8vYECdPBumf2NFmpLEYENxdQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)