UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'btLo9mX+7ax/G9zr54jkeAWlnjz9wMf5/F/5e6tfDxo='
WHERE
key_id = '8afab54498b737880a8ef18772c8779da4fd15cece634b307e99ffc995094b75'
AND (
token = 'btLo9mX+7ax/G9zr54jkeAWlnjz9wMf5/F/5e6tfDxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)