UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X6afTTy736jut3HmIJVHyBJYWcREf7ffgc7CAfPQs+s='
WHERE
key_id = 'afd8ef3400b508c166f24b32b2d4a3b3f241f0ed4ceed8eeed31ae028be7fb91'
AND (
token = 'X6afTTy736jut3HmIJVHyBJYWcREf7ffgc7CAfPQs+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)