UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z46eLC4IsWAjM0DtiSU7uyrQc0YrF4DM5GjNz10OgCc='
WHERE
key_id = '03e5e406b824f64b94ca336c400d6be0d5187c3209d521a45a2b63985d0a13fc'
AND (
token = 'z46eLC4IsWAjM0DtiSU7uyrQc0YrF4DM5GjNz10OgCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)