UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zPJRUnJnD2+SY2PYjrKJO6hMACDGCEkA7f74wFuc5L4='
WHERE
key_id = 'c914835891721a523fd189f0b095d4ffae66495201e82e8f7a527676e5d83ee5'
AND (
token = 'zPJRUnJnD2+SY2PYjrKJO6hMACDGCEkA7f74wFuc5L4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)