UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xh+zUBMAJhjK0V7uVwwl+U0HSPA3IPGLjzxqScwptTk='
WHERE
key_id = 'bc5c60f04b92a6438bb58a1100840019febc44511a6900a3b35710d1e05f0be2'
AND (
token = 'Xh+zUBMAJhjK0V7uVwwl+U0HSPA3IPGLjzxqScwptTk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)