UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6a0wAFVyUdk6nU2Tbz5nnF66MhMFEnRoJz5oZjYI7Oc='
WHERE
key_id = '143b884b3dcd087b35d1cc5500d762bdbdfae27bed9e398e259ffc55b14fb2e9'
AND (
token = '6a0wAFVyUdk6nU2Tbz5nnF66MhMFEnRoJz5oZjYI7Oc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)