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