UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BX9UkWSRiha+4TZWOjPWv7q771LQT9lZMbI8VqHHISg='
WHERE
key_id = '05b99362ca99980beab5f4325d5a6e78595451fa92876397d2cdb4a7792de2ae'
AND (
token = 'BX9UkWSRiha+4TZWOjPWv7q771LQT9lZMbI8VqHHISg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)