UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78GXWPxksK7Sia8AeABgGJ6P4iv+Pwu88Op7Bcla9Xg='
WHERE
key_id = '339f93b0f061aba75cb59ec4ca81c4d9950b29fb52e34c1582d7b832f86e5156'
AND (
token = '78GXWPxksK7Sia8AeABgGJ6P4iv+Pwu88Op7Bcla9Xg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)