UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGC/ICSqHO/Q7A0DhvQpAlPN9aUmTSCq2+I2TMgFR/Y='
WHERE
key_id = '242ed191cbc9839ac1f622ef934a5ecf02b9a3c8515469ef475704bb71cd541d'
AND (
token = 'zGC/ICSqHO/Q7A0DhvQpAlPN9aUmTSCq2+I2TMgFR/Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)