UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'f1zKnFKVAQZrvHngi3dNM9GS0tcDBftrR0tVB1Yqvto='
WHERE
key_id = '204550b1846b535e2311a606e80e62798e826455e5fd5bc3eeca7a8c1e7755f1'
AND (
token = 'f1zKnFKVAQZrvHngi3dNM9GS0tcDBftrR0tVB1Yqvto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)