UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zcxpE2F8nDIqdL8XNfkc6kSfQG69vwaYeGKA36X5CyY='
WHERE
key_id = '7ec19052466e366ae848bd31201bf6378e3b55e0c8a5c564e9e6a98dd79edffc'
AND (
token = 'zcxpE2F8nDIqdL8XNfkc6kSfQG69vwaYeGKA36X5CyY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)