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