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