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