UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZX5FPh0a6gMDen6OWJSjljd1e+jsXkcm89XeXffYVu0='
WHERE
key_id = '1b39d8e49c6d34aa1f4b9d7e999300cfae114147541311c39480723e0ffe0158'
AND (
token = 'ZX5FPh0a6gMDen6OWJSjljd1e+jsXkcm89XeXffYVu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)