UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HS6nFRHM+QOl1f+/75eoCRNIqigu/EVia0Yhv0BW6oc='
WHERE
key_id = 'b3db66884b4bca647c7f33780c3c06f825c59bee07e061148e7752107642a496'
AND (
token = 'HS6nFRHM+QOl1f+/75eoCRNIqigu/EVia0Yhv0BW6oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)