UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bhLH/it9yxfGDELS9a8tVy2+6m3zjWTq/wwU56+VLeg='
WHERE
key_id = '8e33a4e1724e58a1b9447e0aa32bdaf6757492b6448365b5dc19b40ab21c2254'
AND (
token = 'bhLH/it9yxfGDELS9a8tVy2+6m3zjWTq/wwU56+VLeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)