UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nmhVNaZc7rluZ5z+9+qS2MUBPwmBm3zxqwvbiNjzDew='
WHERE
key_id = 'd537ec4c56ed13501739a252b754cbb9037a96945e498b53cf93d49b673bb962'
AND (
token = 'nmhVNaZc7rluZ5z+9+qS2MUBPwmBm3zxqwvbiNjzDew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)