UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0HxYAUxZRRyGTYHL/rrdSKa2HeHrYN4EJuS8fx0vpKg='
WHERE
key_id = 'd933d6bb2c9d0f6526891109ff3bb875658be315e7aac76d7dec55de1dc5b8ad'
AND (
token = '0HxYAUxZRRyGTYHL/rrdSKa2HeHrYN4EJuS8fx0vpKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)